Dataset statistics
| Number of variables | 21 |
|---|---|
| Number of observations | 73086 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 15.4 MiB |
| Average record size in memory | 221.0 B |
Variable types
| Numeric | 13 |
|---|---|
| DateTime | 4 |
| Categorical | 4 |
INITIAL_COST has constant value "" | Constant |
FINAL_COST has constant value "" | Constant |
MAIN_SYSTEM_ID is highly overall correlated with RETAILER_ID | High correlation |
RETAILER_ID is highly overall correlated with MAIN_SYSTEM_ID | High correlation |
LOAN_ID is highly overall correlated with REPAYMENT_ID | High correlation |
LOAN_AMOUNT is highly overall correlated with TOTAL_INITIAL_AMOUNT and 3 other fields | High correlation |
TOTAL_INITIAL_AMOUNT is highly overall correlated with LOAN_AMOUNT and 3 other fields | High correlation |
PAYMENT_AMOUNT is highly overall correlated with LOAN_AMOUNT and 3 other fields | High correlation |
FIRST_TRIAL_BALANCE is highly overall correlated with SPENT and 2 other fields | High correlation |
SPENT is highly overall correlated with LOAN_AMOUNT and 5 other fields | High correlation |
TOTAL_FINAL_AMOUNT is highly overall correlated with LOAN_AMOUNT and 5 other fields | High correlation |
REPAYMENT_ID is highly overall correlated with LOAN_ID | High correlation |
CUMMULATIVE_OUTSTANDING is highly overall correlated with FIRST_TRIAL_BALANCE and 2 other fields | High correlation |
FIRST_TRAIL_DELAYS is highly imbalanced (74.7%) | Imbalance |
PAYMENT_STATUS is highly imbalanced (99.9%) | Imbalance |
REPAYMENT_AMOUNT is highly skewed (γ1 = 68.19202304) | Skewed |
INDEX has unique values | Unique |
LOAN_ID has unique values | Unique |
PAYMENT_AMOUNT has 766 (1.0%) zeros | Zeros |
SPENT has 15465 (21.2%) zeros | Zeros |
TOTAL_FINAL_AMOUNT has 15465 (21.2%) zeros | Zeros |
REPAYMENT_AMOUNT has 72398 (99.1%) zeros | Zeros |
Reproduction
| Analysis started | 2023-04-04 15:40:14.100490 |
|---|---|
| Analysis finished | 2023-04-04 15:40:36.628611 |
| Duration | 22.53 seconds |
| Software version | ydata-profiling vv4.1.2 |
| Download configuration | config.json |
INDEX
Real number (ℝ)
| Distinct | 73086 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 321333.57 |
| Minimum | 10 |
|---|---|
| Maximum | 644668 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 10 |
|---|---|
| 5-th percentile | 31178 |
| Q1 | 160733.75 |
| median | 322029 |
| Q3 | 483033.25 |
| 95-th percentile | 612866 |
| Maximum | 644668 |
| Range | 644658 |
| Interquartile range (IQR) | 322299.5 |
Descriptive statistics
| Standard deviation | 185948.5 |
|---|---|
| Coefficient of variation (CV) | 0.57867747 |
| Kurtosis | -1.1960144 |
| Mean | 321333.57 |
| Median Absolute Deviation (MAD) | 161145.5 |
| Skewness | 0.001457336 |
| Sum | 2.3484985 × 1010 |
| Variance | 3.4576843 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 524291 | 1 | < 0.1% |
| 311207 | 1 | < 0.1% |
| 311271 | 1 | < 0.1% |
| 311268 | 1 | < 0.1% |
| 311259 | 1 | < 0.1% |
| 311237 | 1 | < 0.1% |
| 311232 | 1 | < 0.1% |
| 311214 | 1 | < 0.1% |
| 311206 | 1 | < 0.1% |
| 311287 | 1 | < 0.1% |
| Other values (73076) | 73076 |
| Value | Count | Frequency (%) |
| 10 | 1 | |
| 11 | 1 | |
| 17 | 1 | |
| 31 | 1 | |
| 35 | 1 | |
| 39 | 1 | |
| 73 | 1 | |
| 74 | 1 | |
| 81 | 1 | |
| 83 | 1 |
| Value | Count | Frequency (%) |
| 644668 | 1 | |
| 644667 | 1 | |
| 644666 | 1 | |
| 644665 | 1 | |
| 644654 | 1 | |
| 644650 | 1 | |
| 644648 | 1 | |
| 644647 | 1 | |
| 644646 | 1 | |
| 644633 | 1 |
MAIN_SYSTEM_ID
Real number (ℝ)
| Distinct | 4997 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51831.062 |
| Minimum | 102 |
|---|---|
| Maximum | 156199 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 102 |
|---|---|
| 5-th percentile | 7505 |
| Q1 | 20251 |
| median | 41244 |
| Q3 | 75355 |
| 95-th percentile | 127207 |
| Maximum | 156199 |
| Range | 156097 |
| Interquartile range (IQR) | 55104 |
Descriptive statistics
| Standard deviation | 38218.271 |
|---|---|
| Coefficient of variation (CV) | 0.7373623 |
| Kurtosis | -0.12595415 |
| Mean | 51831.062 |
| Median Absolute Deviation (MAD) | 25088 |
| Skewness | 0.842807 |
| Sum | 3.788125 × 109 |
| Variance | 1.4606362 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 74036 | 219 | 0.3% |
| 48645 | 99 | 0.1% |
| 12578 | 96 | 0.1% |
| 36935 | 82 | 0.1% |
| 32967 | 76 | 0.1% |
| 2972 | 75 | 0.1% |
| 13311 | 72 | 0.1% |
| 44602 | 71 | 0.1% |
| 33890 | 69 | 0.1% |
| 15570 | 69 | 0.1% |
| Other values (4987) | 72158 |
| Value | Count | Frequency (%) |
| 102 | 17 | |
| 115 | 7 | < 0.1% |
| 122 | 1 | < 0.1% |
| 193 | 1 | < 0.1% |
| 247 | 20 | |
| 248 | 5 | < 0.1% |
| 275 | 5 | < 0.1% |
| 290 | 10 | |
| 296 | 1 | < 0.1% |
| 300 | 17 |
| Value | Count | Frequency (%) |
| 156199 | 3 | < 0.1% |
| 156063 | 3 | < 0.1% |
| 155983 | 3 | < 0.1% |
| 155952 | 11 | |
| 155936 | 1 | < 0.1% |
| 155917 | 24 | |
| 155894 | 12 | |
| 155803 | 18 | |
| 155673 | 1 | < 0.1% |
| 155667 | 7 | < 0.1% |
RETAILER_ID
Real number (ℝ)
| Distinct | 4997 |
|---|---|
| Distinct (%) | 6.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 51476.708 |
| Minimum | 64 |
|---|---|
| Maximum | 833111 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 64 |
|---|---|
| 5-th percentile | 5663 |
| Q1 | 18803 |
| median | 40791 |
| Q3 | 75703 |
| 95-th percentile | 103103 |
| Maximum | 833111 |
| Range | 833047 |
| Interquartile range (IQR) | 56900 |
Descriptive statistics
| Standard deviation | 52757.279 |
|---|---|
| Coefficient of variation (CV) | 1.0248767 |
| Kurtosis | 69.087714 |
| Mean | 51476.708 |
| Median Absolute Deviation (MAD) | 25286 |
| Skewness | 6.1235116 |
| Sum | 3.7622267 × 109 |
| Variance | 2.7833305 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 57878 | 219 | 0.3% |
| 78224 | 99 | 0.1% |
| 10413 | 96 | 0.1% |
| 36625 | 82 | 0.1% |
| 30389 | 76 | 0.1% |
| 2177 | 75 | 0.1% |
| 12998 | 72 | 0.1% |
| 48272 | 71 | 0.1% |
| 31649 | 69 | 0.1% |
| 16872 | 69 | 0.1% |
| Other values (4987) | 72158 |
| Value | Count | Frequency (%) |
| 64 | 1 | < 0.1% |
| 286 | 10 | < 0.1% |
| 530 | 1 | < 0.1% |
| 560 | 26 | |
| 814 | 10 | < 0.1% |
| 815 | 15 | < 0.1% |
| 931 | 11 | < 0.1% |
| 1051 | 1 | < 0.1% |
| 1062 | 29 | |
| 1080 | 51 |
| Value | Count | Frequency (%) |
| 833111 | 1 | < 0.1% |
| 832397 | 3 | < 0.1% |
| 792989 | 26 | |
| 790457 | 27 | |
| 780798 | 24 | |
| 737719 | 2 | < 0.1% |
| 709463 | 17 | |
| 664029 | 17 | |
| 629637 | 1 | < 0.1% |
| 627912 | 2 | < 0.1% |
LOAN_ID
Real number (ℝ)
HIGH CORRELATION UNIQUE
| Distinct | 73086 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 831119.78 |
| Minimum | 4917 |
|---|---|
| Maximum | 964571 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 4917 |
|---|---|
| 5-th percentile | 706243 |
| Q1 | 770708 |
| median | 832068.5 |
| Q3 | 897874.75 |
| 95-th percentile | 951253.75 |
| Maximum | 964571 |
| Range | 959654 |
| Interquartile range (IQR) | 127166.75 |
Descriptive statistics
| Standard deviation | 82904.81 |
|---|---|
| Coefficient of variation (CV) | 0.099750737 |
| Kurtosis | 11.522108 |
| Mean | 831119.78 |
| Median Absolute Deviation (MAD) | 64360 |
| Skewness | -1.3326786 |
| Sum | 6.074322 × 1010 |
| Variance | 6.8732076 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 754724 | 1 | < 0.1% |
| 715853 | 1 | < 0.1% |
| 889286 | 1 | < 0.1% |
| 716800 | 1 | < 0.1% |
| 716713 | 1 | < 0.1% |
| 889098 | 1 | < 0.1% |
| 716570 | 1 | < 0.1% |
| 716199 | 1 | < 0.1% |
| 715852 | 1 | < 0.1% |
| 720777 | 1 | < 0.1% |
| Other values (73076) | 73076 |
| Value | Count | Frequency (%) |
| 4917 | 1 | |
| 6151 | 1 | |
| 6157 | 1 | |
| 6256 | 1 | |
| 6271 | 1 | |
| 6275 | 1 | |
| 6326 | 1 | |
| 6345 | 1 | |
| 6365 | 1 | |
| 6367 | 1 |
| Value | Count | Frequency (%) |
| 964571 | 1 | |
| 964570 | 1 | |
| 964566 | 1 | |
| 964564 | 1 | |
| 964563 | 1 | |
| 964562 | 1 | |
| 964561 | 1 | |
| 964557 | 1 | |
| 964556 | 1 | |
| 964554 | 1 |
| Distinct | 73085 |
|---|---|
| Distinct (%) | > 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.1 KiB |
| Minimum | 2021-09-27 15:41:29.692000 |
|---|---|
| Maximum | 2022-10-31 23:54:35.343000 |
Histogram with fixed size bins (bins=50)
LOAN_AMOUNT
Real number (ℝ)
| Distinct | 136 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1722.0188 |
| Minimum | 135 |
|---|---|
| Maximum | 20000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 135 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1000 |
| median | 1500 |
| Q3 | 2000 |
| 95-th percentile | 3000 |
| Maximum | 20000 |
| Range | 19865 |
| Interquartile range (IQR) | 1000 |
Descriptive statistics
| Standard deviation | 897.69607 |
|---|---|
| Coefficient of variation (CV) | 0.52130445 |
| Kurtosis | 15.029727 |
| Mean | 1722.0188 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 2.1050342 |
| Sum | 1.2585547 × 108 |
| Variance | 805858.23 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1000 | 28068 | |
| 1500 | 16000 | |
| 3000 | 11680 | |
| 2000 | 8911 | 12.2% |
| 2500 | 2476 | 3.4% |
| 1200 | 992 | 1.4% |
| 500 | 642 | 0.9% |
| 4000 | 616 | 0.8% |
| 3500 | 543 | 0.7% |
| 5000 | 529 | 0.7% |
| Other values (126) | 2629 | 3.6% |
| Value | Count | Frequency (%) |
| 135 | 1 | < 0.1% |
| 300 | 2 | < 0.1% |
| 359 | 1 | < 0.1% |
| 500 | 642 | |
| 548.81 | 1 | < 0.1% |
| 550 | 2 | < 0.1% |
| 600 | 30 | < 0.1% |
| 647 | 1 | < 0.1% |
| 690 | 1 | < 0.1% |
| 694.88 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 20000 | 2 | < 0.1% |
| 19000 | 1 | < 0.1% |
| 15000 | 6 | < 0.1% |
| 12728 | 1 | < 0.1% |
| 12000 | 2 | < 0.1% |
| 10500 | 1 | < 0.1% |
| 10000 | 18 | |
| 8500 | 14 | |
| 8000 | 15 | |
| 7500 | 7 | < 0.1% |
INITIAL_COST
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 73086 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 73086 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 73086 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 73086 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 73086 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 73086 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 73086 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 73086 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 73086 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 73086 |
TOTAL_INITIAL_AMOUNT
Real number (ℝ)
| Distinct | 136 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1722.0188 |
| Minimum | 135 |
|---|---|
| Maximum | 20000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 135 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1000 |
| median | 1500 |
| Q3 | 2000 |
| 95-th percentile | 3000 |
| Maximum | 20000 |
| Range | 19865 |
| Interquartile range (IQR) | 1000 |
Descriptive statistics
| Standard deviation | 897.69607 |
|---|---|
| Coefficient of variation (CV) | 0.52130445 |
| Kurtosis | 15.029727 |
| Mean | 1722.0188 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 2.1050342 |
| Sum | 1.2585547 × 108 |
| Variance | 805858.23 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1000 | 28068 | |
| 1500 | 16000 | |
| 3000 | 11680 | |
| 2000 | 8911 | 12.2% |
| 2500 | 2476 | 3.4% |
| 1200 | 992 | 1.4% |
| 500 | 642 | 0.9% |
| 4000 | 616 | 0.8% |
| 3500 | 543 | 0.7% |
| 5000 | 529 | 0.7% |
| Other values (126) | 2629 | 3.6% |
| Value | Count | Frequency (%) |
| 135 | 1 | < 0.1% |
| 300 | 2 | < 0.1% |
| 359 | 1 | < 0.1% |
| 500 | 642 | |
| 548.81 | 1 | < 0.1% |
| 550 | 2 | < 0.1% |
| 600 | 30 | < 0.1% |
| 647 | 1 | < 0.1% |
| 690 | 1 | < 0.1% |
| 694.88 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 20000 | 2 | < 0.1% |
| 19000 | 1 | < 0.1% |
| 15000 | 6 | < 0.1% |
| 12728 | 1 | < 0.1% |
| 12000 | 2 | < 0.1% |
| 10500 | 1 | < 0.1% |
| 10000 | 18 | |
| 8500 | 14 | |
| 8000 | 15 | |
| 7500 | 7 | < 0.1% |
INITIAL_DATE
Date
| Distinct | 88 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.1 KiB |
| Minimum | 2021-09-27 00:00:00 |
|---|---|
| Maximum | 2022-11-02 00:00:00 |
Histogram with fixed size bins (bins=50)
| Distinct | 72551 |
|---|---|
| Distinct (%) | 99.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.1 KiB |
| Minimum | 2021-10-06 11:51:38.334000 |
|---|---|
| Maximum | 2022-11-03 16:53:22.774000 |
Histogram with fixed size bins (bins=50)
PAYMENT_AMOUNT
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 286 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1867.8091 |
| Minimum | 0 |
|---|---|
| Maximum | 47000 |
| Zeros | 766 |
| Zeros (%) | 1.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 1000 |
| Q1 | 1000 |
| median | 1500 |
| Q3 | 2500 |
| 95-th percentile | 3750 |
| Maximum | 47000 |
| Range | 47000 |
| Interquartile range (IQR) | 1500 |
Descriptive statistics
| Standard deviation | 1150.8299 |
|---|---|
| Coefficient of variation (CV) | 0.61613892 |
| Kurtosis | 56.13891 |
| Mean | 1867.8091 |
| Median Absolute Deviation (MAD) | 500 |
| Skewness | 3.5970973 |
| Sum | 1.3651069 × 108 |
| Variance | 1324409.4 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1000 | 17395 | |
| 1500 | 11631 | |
| 3000 | 8270 | |
| 2000 | 7710 | |
| 1100 | 2606 | 3.6% |
| 2500 | 2201 | 3.0% |
| 1050 | 1973 | 2.7% |
| 1200 | 1751 | 2.4% |
| 1600 | 1733 | 2.4% |
| 3100 | 1445 | 2.0% |
| Other values (276) | 16371 |
| Value | Count | Frequency (%) |
| 0 | 766 | |
| 0.16 | 1 | < 0.1% |
| 50 | 2 | < 0.1% |
| 100 | 12 | < 0.1% |
| 150 | 2 | < 0.1% |
| 200 | 12 | < 0.1% |
| 250 | 6 | < 0.1% |
| 300 | 137 | 0.2% |
| 320 | 1 | < 0.1% |
| 350 | 12 | < 0.1% |
| Value | Count | Frequency (%) |
| 47000 | 1 | < 0.1% |
| 30000 | 1 | < 0.1% |
| 29500 | 1 | < 0.1% |
| 20000 | 6 | |
| 19000 | 1 | < 0.1% |
| 18000 | 1 | < 0.1% |
| 15600 | 1 | < 0.1% |
| 15500 | 1 | < 0.1% |
| 15000 | 3 | |
| 13500 | 1 | < 0.1% |
FIRST_TRAIL_DELAYS
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| 0 | |
|---|---|
| 1 | 5808 |
| 2 | 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 73086 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 1 ? |
|---|---|
| Unique (%) | < 0.1% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 67277 | |
| 1 | 5808 | 7.9% |
| 2 | 1 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 67277 | |
| 1 | 5808 | 7.9% |
| 2 | 1 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 67277 | |
| 1 | 5808 | 7.9% |
| 2 | 1 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 73086 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 67277 | |
| 1 | 5808 | 7.9% |
| 2 | 1 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 73086 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 67277 | |
| 1 | 5808 | 7.9% |
| 2 | 1 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 73086 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 67277 | |
| 1 | 5808 | 7.9% |
| 2 | 1 | < 0.1% |
FIRST_TRIAL_BALANCE
Real number (ℝ)
| Distinct | 58978 |
|---|---|
| Distinct (%) | 80.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1113.6922 |
| Minimum | -14324.51 |
|---|---|
| Maximum | 40269.9 |
| Zeros | 105 |
| Zeros (%) | 0.1% |
| Negative | 695 |
| Negative (%) | 1.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | -14324.51 |
|---|---|
| 5-th percentile | 3.4225 |
| Q1 | 335.2575 |
| median | 906.28 |
| Q3 | 1374.9275 |
| 95-th percentile | 3116.2025 |
| Maximum | 40269.9 |
| Range | 54594.41 |
| Interquartile range (IQR) | 1039.67 |
Descriptive statistics
| Standard deviation | 1430.9159 |
|---|---|
| Coefficient of variation (CV) | 1.2848396 |
| Kurtosis | 60.525786 |
| Mean | 1113.6922 |
| Median Absolute Deviation (MAD) | 524.62 |
| Skewness | 5.3509308 |
| Sum | 81395312 |
| Variance | 2047520.3 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 105 | 0.1% |
| 0.66 | 26 | < 0.1% |
| 0.67 | 25 | < 0.1% |
| 0.36 | 23 | < 0.1% |
| 0.97 | 21 | < 0.1% |
| 1.06 | 21 | < 0.1% |
| 0.24 | 21 | < 0.1% |
| 0.41 | 20 | < 0.1% |
| 1.35 | 19 | < 0.1% |
| 0.81 | 19 | < 0.1% |
| Other values (58968) | 72786 |
| Value | Count | Frequency (%) |
| -14324.51 | 1 | |
| -11953.44 | 1 | |
| -4413.4 | 1 | |
| -4408.37 | 1 | |
| -3999.12 | 1 | |
| -3995.89 | 1 | |
| -3991.98 | 2 | |
| -3863.15 | 1 | |
| -3750.19 | 1 | |
| -3591.34 | 1 |
| Value | Count | Frequency (%) |
| 40269.9 | 1 | |
| 35851.45 | 2 | |
| 31078.73 | 1 | |
| 30178.21 | 1 | |
| 30138.72 | 1 | |
| 25770.39 | 1 | |
| 23706.6 | 1 | |
| 23478.21 | 1 | |
| 23039.55 | 1 | |
| 22525.77 | 1 |
SPENT
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 47382 |
|---|---|
| Distinct (%) | 64.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 893.89495 |
| Minimum | 0 |
|---|---|
| Maximum | 19882.51 |
| Zeros | 15465 |
| Zeros (%) | 21.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 48.26 |
| median | 582.775 |
| Q3 | 1402.7175 |
| 95-th percentile | 2990.7713 |
| Maximum | 19882.51 |
| Range | 19882.51 |
| Interquartile range (IQR) | 1354.4575 |
Descriptive statistics
| Standard deviation | 993.12137 |
|---|---|
| Coefficient of variation (CV) | 1.1110046 |
| Kurtosis | 5.4574873 |
| Mean | 893.89495 |
| Median Absolute Deviation (MAD) | 582.775 |
| Skewness | 1.5548884 |
| Sum | 65331206 |
| Variance | 986290.06 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 15465 | 21.2% |
| 2999.33 | 17 | < 0.1% |
| 2999.37 | 16 | < 0.1% |
| 2999.15 | 15 | < 0.1% |
| 2998.65 | 15 | < 0.1% |
| 999.34 | 14 | < 0.1% |
| 2998.94 | 14 | < 0.1% |
| 2999.11 | 13 | < 0.1% |
| 2999.59 | 13 | < 0.1% |
| 2999.65 | 12 | < 0.1% |
| Other values (47372) | 57492 |
| Value | Count | Frequency (%) |
| 0 | 15465 | |
| 0.04 | 1 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.06 | 1 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.1 | 1 | < 0.1% |
| 0.11 | 1 | < 0.1% |
| 0.12 | 2 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 19882.51 | 1 | |
| 14999.88 | 1 | |
| 14324.51 | 1 | |
| 11953.44 | 1 | |
| 11148.55 | 1 | |
| 10116.03 | 1 | |
| 9998.99 | 1 | |
| 9998.6 | 1 | |
| 9996.2 | 1 | |
| 9972.42 | 1 |
FINAL_COST
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.0 MiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 73086 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 73086 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 73086 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 73086 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 73086 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 73086 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 73086 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 73086 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 73086 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 73086 |
TOTAL_FINAL_AMOUNT
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 47382 |
|---|---|
| Distinct (%) | 64.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 893.89495 |
| Minimum | 0 |
|---|---|
| Maximum | 19882.51 |
| Zeros | 15465 |
| Zeros (%) | 21.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 48.26 |
| median | 582.775 |
| Q3 | 1402.7175 |
| 95-th percentile | 2990.7713 |
| Maximum | 19882.51 |
| Range | 19882.51 |
| Interquartile range (IQR) | 1354.4575 |
Descriptive statistics
| Standard deviation | 993.12137 |
|---|---|
| Coefficient of variation (CV) | 1.1110046 |
| Kurtosis | 5.4574873 |
| Mean | 893.89495 |
| Median Absolute Deviation (MAD) | 582.775 |
| Skewness | 1.5548884 |
| Sum | 65331206 |
| Variance | 986290.06 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 15465 | 21.2% |
| 2999.33 | 17 | < 0.1% |
| 2999.37 | 16 | < 0.1% |
| 2999.15 | 15 | < 0.1% |
| 2998.65 | 15 | < 0.1% |
| 999.34 | 14 | < 0.1% |
| 2998.94 | 14 | < 0.1% |
| 2999.11 | 13 | < 0.1% |
| 2999.59 | 13 | < 0.1% |
| 2999.65 | 12 | < 0.1% |
| Other values (47372) | 57492 |
| Value | Count | Frequency (%) |
| 0 | 15465 | |
| 0.04 | 1 | < 0.1% |
| 0.05 | 1 | < 0.1% |
| 0.06 | 1 | < 0.1% |
| 0.07 | 1 | < 0.1% |
| 0.1 | 1 | < 0.1% |
| 0.11 | 1 | < 0.1% |
| 0.12 | 2 | < 0.1% |
| 0.13 | 1 | < 0.1% |
| 0.14 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 19882.51 | 1 | |
| 14999.88 | 1 | |
| 14324.51 | 1 | |
| 11953.44 | 1 | |
| 11148.55 | 1 | |
| 10116.03 | 1 | |
| 9998.99 | 1 | |
| 9998.6 | 1 | |
| 9996.2 | 1 | |
| 9972.42 | 1 |
REPAYMENT_ID
Real number (ℝ)
| Distinct | 73021 |
|---|---|
| Distinct (%) | 99.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 831355.02 |
| Minimum | 4917 |
|---|---|
| Maximum | 1520356 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | 4917 |
|---|---|
| 5-th percentile | 706349.75 |
| Q1 | 770823 |
| median | 832201.5 |
| Q3 | 897996.75 |
| 95-th percentile | 951407.5 |
| Maximum | 1520356 |
| Range | 1515439 |
| Interquartile range (IQR) | 127173.75 |
Descriptive statistics
| Standard deviation | 83170.353 |
|---|---|
| Coefficient of variation (CV) | 0.10004192 |
| Kurtosis | 11.578458 |
| Mean | 831355.02 |
| Median Absolute Deviation (MAD) | 64387.5 |
| Skewness | -1.2877125 |
| Sum | 6.0760413 × 1010 |
| Variance | 6.9173076 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 924749 | 3 | < 0.1% |
| 885753 | 2 | < 0.1% |
| 936087 | 2 | < 0.1% |
| 936242 | 2 | < 0.1% |
| 925768 | 2 | < 0.1% |
| 905030 | 2 | < 0.1% |
| 819766 | 2 | < 0.1% |
| 948812 | 2 | < 0.1% |
| 948444 | 2 | < 0.1% |
| 917815 | 2 | < 0.1% |
| Other values (73011) | 73065 |
| Value | Count | Frequency (%) |
| 4917 | 1 | |
| 6151 | 1 | |
| 6157 | 1 | |
| 6256 | 1 | |
| 6271 | 1 | |
| 6275 | 1 | |
| 6326 | 1 | |
| 6345 | 1 | |
| 6365 | 1 | |
| 6367 | 1 |
| Value | Count | Frequency (%) |
| 1520356 | 1 | |
| 1455996 | 1 | |
| 1378520 | 1 | |
| 1345681 | 1 | |
| 1306725 | 1 | |
| 1280781 | 1 | |
| 1272046 | 1 | |
| 1255607 | 1 | |
| 1210023 | 1 | |
| 1187193 | 1 |
REPAYMENT_AMOUNT
Real number (ℝ)
SKEWED ZEROS
| Distinct | 193 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 13.561667 |
| Minimum | -2.49 |
|---|---|
| Maximum | 35283 |
| Zeros | 72398 |
| Zeros (%) | 99.1% |
| Negative | 1 |
| Negative (%) | < 0.1% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | -2.49 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 35283 |
| Range | 35285.49 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 219.68641 |
|---|---|
| Coefficient of variation (CV) | 16.199072 |
| Kurtosis | 9436.309 |
| Mean | 13.561667 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 68.192023 |
| Sum | 991167.96 |
| Variance | 48262.121 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 72398 | |
| 1000 | 104 | 0.1% |
| 1500 | 59 | 0.1% |
| 2000 | 54 | 0.1% |
| 3000 | 50 | 0.1% |
| 500 | 35 | < 0.1% |
| 2500 | 17 | < 0.1% |
| 300 | 15 | < 0.1% |
| 100 | 14 | < 0.1% |
| 1200 | 14 | < 0.1% |
| Other values (183) | 326 | 0.4% |
| Value | Count | Frequency (%) |
| -2.49 | 1 | < 0.1% |
| 0 | 72398 | |
| 3 | 1 | < 0.1% |
| 5 | 3 | < 0.1% |
| 6 | 1 | < 0.1% |
| 6.68 | 1 | < 0.1% |
| 10 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 20 | 3 | < 0.1% |
| 30 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 35283 | 1 | |
| 13000 | 1 | |
| 10000 | 1 | |
| 7500 | 1 | |
| 6440 | 1 | |
| 6320 | 1 | |
| 5020 | 1 | |
| 5000 | 1 | |
| 4515 | 1 | |
| 4500 | 2 |
| Distinct | 72534 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 571.1 KiB |
| Minimum | 2021-10-06 11:51:38.334000 |
|---|---|
| Maximum | 2023-02-09 17:30:18.093000 |
Histogram with fixed size bins (bins=50)
CUMMULATIVE_OUTSTANDING
Real number (ℝ)
| Distinct | 58902 |
|---|---|
| Distinct (%) | 80.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1128.3532 |
| Minimum | -3750.19 |
|---|---|
| Maximum | 40269.9 |
| Zeros | 107 |
| Zeros (%) | 0.1% |
| Negative | 9 |
| Negative (%) | < 0.1% |
| Memory size | 571.1 KiB |
Quantile statistics
| Minimum | -3750.19 |
|---|---|
| 5-th percentile | 4.2225 |
| Q1 | 341.1425 |
| median | 907.815 |
| Q3 | 1376.0225 |
| 95-th percentile | 3117.7775 |
| Maximum | 40269.9 |
| Range | 44020.09 |
| Interquartile range (IQR) | 1034.88 |
Descriptive statistics
| Standard deviation | 1416.3257 |
|---|---|
| Coefficient of variation (CV) | 1.2552149 |
| Kurtosis | 65.802325 |
| Mean | 1128.3532 |
| Median Absolute Deviation (MAD) | 522.31 |
| Skewness | 5.7290155 |
| Sum | 82466821 |
| Variance | 2005978.6 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 107 | 0.1% |
| 0.66 | 26 | < 0.1% |
| 0.67 | 25 | < 0.1% |
| 0.36 | 23 | < 0.1% |
| 0.97 | 21 | < 0.1% |
| 1.06 | 21 | < 0.1% |
| 0.24 | 21 | < 0.1% |
| 0.41 | 20 | < 0.1% |
| 1.35 | 19 | < 0.1% |
| 0.81 | 19 | < 0.1% |
| Other values (58892) | 72784 |
| Value | Count | Frequency (%) |
| -3750.19 | 1 | < 0.1% |
| -2942.85 | 1 | < 0.1% |
| -2498.01 | 1 | < 0.1% |
| -1496.84 | 1 | < 0.1% |
| -1195.51 | 1 | < 0.1% |
| -1000.91 | 1 | < 0.1% |
| -792.56 | 1 | < 0.1% |
| -738.62 | 1 | < 0.1% |
| -470.2 | 1 | < 0.1% |
| 0 | 107 |
| Value | Count | Frequency (%) |
| 40269.9 | 1 | |
| 35851.45 | 2 | |
| 32483.78 | 1 | |
| 31078.73 | 1 | |
| 30178.21 | 1 | |
| 30138.72 | 1 | |
| 25770.39 | 1 | |
| 23706.6 | 1 | |
| 23478.21 | 1 | |
| 23039.55 | 1 |
PAYMENT_STATUS
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| Paid | |
|---|---|
| Unpaid | 6 |
| Partialy paid | 3 |
Length
| Max length | 13 |
|---|---|
| Median length | 4 |
| Mean length | 4.0005336 |
| Min length | 4 |
Characters and Unicode
| Total characters | 292383 |
|---|---|
| Distinct characters | 12 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Paid |
|---|---|
| 2nd row | Paid |
| 3rd row | Paid |
| 4th row | Paid |
| 5th row | Paid |
Common Values
| Value | Count | Frequency (%) |
| Paid | 73077 | |
| Unpaid | 6 | < 0.1% |
| Partialy paid | 3 | < 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| paid | 73080 | |
| unpaid | 6 | < 0.1% |
| partialy | 3 | < 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 73092 | |
| i | 73089 | |
| d | 73086 | |
| P | 73080 | |
| p | 9 | < 0.1% |
| U | 6 | < 0.1% |
| n | 6 | < 0.1% |
| r | 3 | < 0.1% |
| t | 3 | < 0.1% |
| l | 3 | < 0.1% |
| Other values (2) | 6 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 219294 | |
| Uppercase Letter | 73086 | 25.0% |
| Space Separator | 3 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 73092 | |
| i | 73089 | |
| d | 73086 | |
| p | 9 | < 0.1% |
| n | 6 | < 0.1% |
| r | 3 | < 0.1% |
| t | 3 | < 0.1% |
| l | 3 | < 0.1% |
| y | 3 | < 0.1% |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 73080 | |
| U | 6 | < 0.1% |
Space Separator
| Value | Count | Frequency (%) |
| 3 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 292380 | |
| Common | 3 | < 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 73092 | |
| i | 73089 | |
| d | 73086 | |
| P | 73080 | |
| p | 9 | < 0.1% |
| U | 6 | < 0.1% |
| n | 6 | < 0.1% |
| r | 3 | < 0.1% |
| t | 3 | < 0.1% |
| l | 3 | < 0.1% |
Common
| Value | Count | Frequency (%) |
| 3 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 292383 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 73092 | |
| i | 73089 | |
| d | 73086 | |
| P | 73080 | |
| p | 9 | < 0.1% |
| U | 6 | < 0.1% |
| n | 6 | < 0.1% |
| r | 3 | < 0.1% |
| t | 3 | < 0.1% |
| l | 3 | < 0.1% |
| Other values (2) | 6 | < 0.1% |
| INDEX | MAIN_SYSTEM_ID | RETAILER_ID | LOAN_ID | LOAN_AMOUNT | TOTAL_INITIAL_AMOUNT | PAYMENT_AMOUNT | FIRST_TRIAL_BALANCE | SPENT | TOTAL_FINAL_AMOUNT | REPAYMENT_ID | REPAYMENT_AMOUNT | CUMMULATIVE_OUTSTANDING | FIRST_TRAIL_DELAYS | PAYMENT_STATUS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INDEX | 1.000 | -0.004 | -0.005 | -0.006 | 0.001 | 0.001 | -0.003 | -0.001 | 0.000 | 0.000 | -0.006 | 0.004 | -0.001 | 0.000 | 0.000 |
| MAIN_SYSTEM_ID | -0.004 | 1.000 | 0.958 | 0.013 | -0.109 | -0.109 | -0.098 | 0.020 | -0.089 | -0.089 | 0.013 | 0.003 | 0.021 | 0.014 | 0.013 |
| RETAILER_ID | -0.005 | 0.958 | 1.000 | 0.013 | -0.097 | -0.097 | -0.088 | 0.013 | -0.079 | -0.079 | 0.013 | 0.005 | 0.014 | 0.016 | 0.000 |
| LOAN_ID | -0.006 | 0.013 | 0.013 | 1.000 | 0.012 | 0.012 | 0.010 | 0.015 | -0.005 | -0.005 | 0.999 | -0.008 | 0.015 | 0.018 | 0.028 |
| LOAN_AMOUNT | 0.001 | -0.109 | -0.097 | 0.012 | 1.000 | 1.000 | 0.885 | 0.044 | 0.611 | 0.611 | 0.012 | 0.012 | 0.044 | 0.018 | 0.000 |
| TOTAL_INITIAL_AMOUNT | 0.001 | -0.109 | -0.097 | 0.012 | 1.000 | 1.000 | 0.885 | 0.044 | 0.611 | 0.611 | 0.012 | 0.012 | 0.044 | 0.018 | 0.000 |
| PAYMENT_AMOUNT | -0.003 | -0.098 | -0.088 | 0.010 | 0.885 | 0.885 | 1.000 | 0.212 | 0.534 | 0.534 | 0.006 | -0.151 | 0.203 | 0.010 | 0.000 |
| FIRST_TRIAL_BALANCE | -0.001 | 0.020 | 0.013 | 0.015 | 0.044 | 0.044 | 0.212 | 1.000 | -0.607 | -0.607 | 0.012 | -0.167 | 0.996 | 0.056 | 0.079 |
| SPENT | 0.000 | -0.089 | -0.079 | -0.005 | 0.611 | 0.611 | 0.534 | -0.607 | 1.000 | 1.000 | -0.004 | 0.043 | -0.609 | 0.052 | 0.005 |
| TOTAL_FINAL_AMOUNT | 0.000 | -0.089 | -0.079 | -0.005 | 0.611 | 0.611 | 0.534 | -0.607 | 1.000 | 1.000 | -0.004 | 0.043 | -0.609 | 0.052 | 0.005 |
| REPAYMENT_ID | -0.006 | 0.013 | 0.013 | 0.999 | 0.012 | 0.012 | 0.006 | 0.012 | -0.004 | -0.004 | 1.000 | 0.011 | 0.012 | 0.032 | 0.369 |
| REPAYMENT_AMOUNT | 0.004 | 0.003 | 0.005 | -0.008 | 0.012 | 0.012 | -0.151 | -0.167 | 0.043 | 0.043 | 0.011 | 1.000 | -0.106 | 0.036 | 0.000 |
| CUMMULATIVE_OUTSTANDING | -0.001 | 0.021 | 0.014 | 0.015 | 0.044 | 0.044 | 0.203 | 0.996 | -0.609 | -0.609 | 0.012 | -0.106 | 1.000 | 0.104 | 0.000 |
| FIRST_TRAIL_DELAYS | 0.000 | 0.014 | 0.016 | 0.018 | 0.018 | 0.018 | 0.010 | 0.056 | 0.052 | 0.052 | 0.032 | 0.036 | 0.104 | 1.000 | 0.023 |
| PAYMENT_STATUS | 0.000 | 0.013 | 0.000 | 0.028 | 0.000 | 0.000 | 0.000 | 0.079 | 0.005 | 0.005 | 0.369 | 0.000 | 0.000 | 0.023 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| INDEX | MAIN_SYSTEM_ID | RETAILER_ID | LOAN_ID | LOAN_ISSUANCE_DATE | LOAN_AMOUNT | INITIAL_COST | TOTAL_INITIAL_AMOUNT | INITIAL_DATE | LOAN_PAYMENT_DATE | PAYMENT_AMOUNT | FIRST_TRAIL_DELAYS | FIRST_TRIAL_BALANCE | SPENT | FINAL_COST | TOTAL_FINAL_AMOUNT | REPAYMENT_ID | REPAYMENT_AMOUNT | REPAYMENT_UPDATED | CUMMULATIVE_OUTSTANDING | PAYMENT_STATUS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 524291 | 35668 | 34019 | 754724 | 2022-09-13 07:58:24.292 | 1000.0 | 0 | 1000.0 | 2022-09-13 | 2022-09-13 16:39:44.127 | 1020.0 | 0 | 975.39 | 44.61 | 0 | 44.61 | 754724 | 0.0 | 2022-09-13 16:39:44.127 | 975.39 | Paid |
| 1 | 524292 | 25120 | 28232 | 754770 | 2022-09-13 08:24:02.824 | 3000.0 | 0 | 3000.0 | 2022-09-14 | 2022-09-14 11:28:18.887 | 3000.0 | 0 | 2.17 | 2997.83 | 0 | 2997.83 | 754770 | 0.0 | 2022-09-14 11:28:18.887 | 2.17 | Paid |
| 2 | 524293 | 20838 | 23156 | 754814 | 2022-09-13 08:47:08.021 | 1500.0 | 0 | 1500.0 | 2022-09-13 | 2022-09-14 19:49:44.283 | 1500.0 | 1 | 21.15 | 1478.85 | 0 | 1478.85 | 754814 | 0.0 | 2022-09-14 19:49:44.283 | 21.15 | Paid |
| 3 | 524321 | 7080 | 5077 | 755041 | 2022-09-13 09:39:29.577 | 1000.0 | 0 | 1000.0 | 2022-09-13 | 2022-09-13 10:35:35.906 | 1100.0 | 0 | 1102.01 | 0.00 | 0 | 0.00 | 755041 | 0.0 | 2022-09-13 10:35:35.906 | 1102.01 | Paid |
| 4 | 524322 | 24892 | 21413 | 755076 | 2022-09-13 09:52:06.680 | 2000.0 | 0 | 2000.0 | 2022-09-14 | 2022-09-14 12:16:17.279 | 2000.0 | 0 | 890.02 | 1109.98 | 0 | 1109.98 | 755076 | 0.0 | 2022-09-14 12:16:17.279 | 890.02 | Paid |
| 5 | 524323 | 30739 | 29253 | 755089 | 2022-09-13 09:56:28.417 | 1000.0 | 0 | 1000.0 | 2022-09-13 | 2022-09-13 12:29:49.086 | 1100.0 | 0 | 1095.43 | 4.57 | 0 | 4.57 | 755089 | 0.0 | 2022-09-13 12:29:49.086 | 1095.43 | Paid |
| 6 | 524331 | 38767 | 36398 | 909794 | 2022-10-19 19:09:08.510 | 2000.0 | 0 | 2000.0 | 2022-10-20 | 2022-10-20 14:00:31.399 | 2000.0 | 0 | 171.78 | 1828.22 | 0 | 1828.22 | 909794 | 0.0 | 2022-10-20 14:00:31.399 | 171.78 | Paid |
| 7 | 524332 | 35241 | 37165 | 909926 | 2022-10-19 20:02:32.191 | 1500.0 | 0 | 1500.0 | 2022-10-20 | 2022-10-20 09:39:53.797 | 1500.0 | 0 | 1459.92 | 40.08 | 0 | 40.08 | 909926 | 0.0 | 2022-10-20 09:39:53.797 | 1459.92 | Paid |
| 8 | 524335 | 306 | 1299 | 910224 | 2022-10-19 22:14:15.620 | 1500.0 | 0 | 1500.0 | 2022-10-21 | 2022-10-21 11:09:08.623 | 1500.0 | 0 | 1269.72 | 230.28 | 0 | 230.28 | 910224 | 0.0 | 2022-10-21 11:09:08.623 | 1269.72 | Paid |
| 9 | 524336 | 40107 | 53906 | 910277 | 2022-10-19 22:28:33.175 | 1500.0 | 0 | 1500.0 | 2022-10-20 | 2022-10-20 11:16:49.724 | 1000.0 | 0 | 645.42 | 354.58 | 0 | 354.58 | 910277 | 0.0 | 2022-10-20 11:16:49.724 | 645.42 | Paid |
| INDEX | MAIN_SYSTEM_ID | RETAILER_ID | LOAN_ID | LOAN_ISSUANCE_DATE | LOAN_AMOUNT | INITIAL_COST | TOTAL_INITIAL_AMOUNT | INITIAL_DATE | LOAN_PAYMENT_DATE | PAYMENT_AMOUNT | FIRST_TRAIL_DELAYS | FIRST_TRIAL_BALANCE | SPENT | FINAL_COST | TOTAL_FINAL_AMOUNT | REPAYMENT_ID | REPAYMENT_AMOUNT | REPAYMENT_UPDATED | CUMMULATIVE_OUTSTANDING | PAYMENT_STATUS | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 73076 | 262056 | 44417 | 54165 | 902616 | 2022-10-19 05:12:53.201 | 3000.0 | 0 | 3000.0 | 2022-10-20 | 2022-10-20 14:28:46.238 | 3000.0 | 0 | 0.40 | 2999.60 | 0 | 2999.60 | 902616 | 0.0 | 2022-10-20 14:28:46.238 | 0.40 | Paid |
| 73077 | 262057 | 148931 | 93940 | 902639 | 2022-10-19 05:35:13.340 | 3000.0 | 0 | 3000.0 | 2022-10-20 | 2022-10-20 15:01:56.425 | 3000.0 | 0 | 1167.93 | 1832.07 | 0 | 1832.07 | 902639 | 0.0 | 2022-10-20 15:01:56.425 | 1167.93 | Paid |
| 73078 | 262061 | 62409 | 65164 | 753463 | 2022-09-12 17:56:13.020 | 1500.0 | 0 | 1500.0 | 2022-09-12 | 2022-09-12 19:35:45.107 | 1500.0 | 0 | 1338.84 | 161.16 | 0 | 161.16 | 753463 | 0.0 | 2022-09-12 19:35:45.107 | 1338.84 | Paid |
| 73079 | 262067 | 29363 | 28364 | 903083 | 2022-10-19 08:42:30.359 | 3000.0 | 0 | 3000.0 | 2022-10-20 | 2022-10-20 16:07:59.336 | 3000.0 | 0 | 203.62 | 2796.38 | 0 | 2796.38 | 903083 | 0.0 | 2022-10-20 16:07:59.336 | 203.62 | Paid |
| 73080 | 262087 | 60590 | 60559 | 753826 | 2022-09-12 19:40:03.566 | 2500.0 | 0 | 2500.0 | 2022-09-13 | 2022-09-13 19:25:07.646 | 1000.0 | 1 | 99.34 | 900.66 | 0 | 900.66 | 753826 | 0.0 | 2022-09-13 19:25:07.646 | 99.34 | Paid |
| 73081 | 262090 | 76433 | 69086 | 753863 | 2022-09-12 19:51:28.684 | 1000.0 | 0 | 1000.0 | 2022-09-13 | 2022-09-13 16:19:38.894 | 1000.0 | 0 | 566.18 | 433.82 | 0 | 433.82 | 753863 | 0.0 | 2022-09-13 16:19:38.894 | 566.18 | Paid |
| 73082 | 262094 | 66308 | 86666 | 753957 | 2022-09-12 20:34:54.379 | 1000.0 | 0 | 1000.0 | 2022-09-13 | 2022-09-13 20:03:52.787 | 1000.0 | 0 | 336.71 | 663.29 | 0 | 663.29 | 753957 | 0.0 | 2022-09-13 20:03:52.787 | 336.71 | Paid |
| 73083 | 262096 | 12522 | 8486 | 754026 | 2022-09-12 21:16:55.893 | 1500.0 | 0 | 1500.0 | 2022-09-13 | 2022-09-13 12:51:57.996 | 1600.0 | 0 | 479.38 | 1120.62 | 0 | 1120.62 | 754026 | 0.0 | 2022-09-13 12:51:57.996 | 479.38 | Paid |
| 73084 | 262098 | 117325 | 216091 | 754160 | 2022-09-12 22:06:32.186 | 3000.0 | 0 | 3000.0 | 2022-09-14 | 2022-09-14 08:51:45.437 | 3200.0 | 0 | 205.29 | 2994.71 | 0 | 2994.71 | 754160 | 0.0 | 2022-09-14 08:51:45.437 | 205.29 | Paid |
| 73085 | 262133 | 149207 | 91515 | 905154 | 2022-10-19 11:30:45.522 | 1500.0 | 0 | 1500.0 | 2022-10-20 | 2022-10-20 17:11:11.571 | 1500.0 | 0 | 964.00 | 536.00 | 0 | 536.00 | 905154 | 0.0 | 2022-10-20 17:11:11.571 | 964.00 | Paid |